


*************************
**** 	TABLE 7 	*****
*************************	

		*use "Orbis Data/Subsidiaries/NLOrbis_819level.dta", replace  	// Data with proprietary variables from ICAO/Orbis
		use "Data_for_Table7.dta", replace	  							// Data without proprietary variables 
		global CONTROLS0_EI "EIGEN89_55to65 regdum*"
		global TZONE_DistEq "timezone_fullhours ldist_eq" 
		global NLPOP819 "Lights92_025grid pop90_025grid"
		global CONTROLS1989  "z_EIGEN_1989 totnr_twice1989 totnr_weekly1989 totnr_daily1989  ltotnr_cityconnects1989 totnr_states_twice1989 ltotnr_seats1989 ltotnr_flights1989 ltotnr_passengers1989 nrcities_55to65" 	
		capture erase "results/Table_7.xls"
		capture erase "results/Table_7.txt"
		set more off
		
		*-FIRST STAGES-*
		reg z_EIGEN_2014  	   shareEI_below6000_w500  							 						   	$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		reg z_EIGEN_2014  	   shareEI_below6000_w500  shareEI_below6000_w500_X10 						   	$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		reg z_EIGEN_2014_X10  shareEI_below6000_w500  shareEI_below6000_w500_X10 						   	$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		*-RF: 5K-6K-*
		reg zcompany_nr_dist6000  shareEI_below6000_w500  													$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500) ctitle("Owned by Foreigners, 5K-6K") 
		reg zcompany_nr_dist6000  shareEI_below6000_w500  shareEI_below6000_w500_X10 						$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		*-IV/2SLS: 5K-6K-*
		ivreg2 zcompany_nr_dist6000  (z_EIGEN_2014 z_EIGEN_2014_X10=shareEI_below6000_w500  shareEI_below6000_w500_X10) $CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode) ffirst	
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(z_EIGEN_2014 z_EIGEN_2014_X10) ctitle("Owned by Foreigners, 5K-6K") 
		*-RF: total number firms-*
		reg zcompany_nr_dist2K6K  shareEI_below6000_w500   						   							$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		reg zcompany_nr_dist2K6K  shareEI_below6000_w500  shareEI_below6000_w500_X10 						$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		*-IV/2SLS: total number firms-*
		ivreg2 zcompany_nr_dist2K6K  (z_EIGEN_2014 z_EIGEN_2014_X10=shareEI_below6000_w500  shareEI_below6000_w500_X10) $CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode) ffirst	
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(z_EIGEN_2014 z_EIGEN_2014_X10) ctitle("Owned by Foreigners, 5K-6K") 
	
		*NIGHT LIGHTS
		reg zNL9210_growth  shareEI_below6000_w500  						   								$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		reg zNL9210_growth  shareEI_below6000_w500  shareEI_below6000_w500_X10 						   		$CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode)		
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(shareEI_below6000_w500 shareEI_below6000_w500_X10) ctitle("Owned by Foreigners, 5K-6K") 
		ivreg2 zNL9210_growth  (z_EIGEN_2014 z_EIGEN_2014_X10=shareEI_below6000_w500  shareEI_below6000_w500_X10) $CONTROLS0_EI $TZONE_DistEq $NLPOP819 $CONTROLS1989, cl(countrycode) ffirst	
		outreg2    using "results/Table_7.xls", se nocons dec(3) keep(z_EIGEN_2014 z_EIGEN_2014_X10) ctitle("Owned by Foreigners, 5K-6K") 

		
